package cn.edu.zut.cs.DAO;

import cn.edu.zut.cs.Model.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface UserDAO {
    //用户表
    void insertUser(User user);
    void modifyUser(User user);
    String queryPassWord(String UserName);
    String queryUserName(String UserName);
    String queryRole(String UserName);
    Integer queryUserID(String UserName);
    List<User> queryAll();  //返回所有用户信息
    List<User> queryOneUser(String UserName);   //返回一个用户信息
    void modifyBookNum(User user);    //通过用户名修改预定车位号
    Integer queryBookNum(String UserName);
    Integer queryVIPLotID(String UserName);
    void modifyVIPLotID(User user); //修改用户表中的身份、VIPLotID、VIPTime
    String queryVIPTime(String UserName);
    void modifyVIPTime(User user);
    void modifyOutBookNum(String UserName);
    void minusVIPuser(String UserName);
    String queryVIPRole(int UserID);
    String getUserName(int UserID);
    List<User> queryAllVIP();  //返回所有用户信息
    void insertBookTime(User user);
    List<User> queryAllBook();  //查询所有的预定用户
    void minusBook(String UserName);
    String queryBookTime(String UserName);
    void modifyBookTime(String UserName);
}
